using FarPoint.Win.Spread;
using GrapeCity.Spreadsheet;
using System;
using System.Drawing;

namespace Spread.Sparkline.Features
{
    public partial class HistogramSparkline : Spread.Common.Features.Sample.BaseSampleControl
    {
        private Random _rand;
        public HistogramSparkline()
        {
            InitializeComponent();
            Name = "Histogram";
            _rand = new Random();
            InitSpreadSheet(_fpSpread.ActiveSheet);
        }

        #region Private Methods
        private void InitSpreadSheet(SheetView sheetView)
        {
            var worksheet = sheetView.AsWorksheet();
            worksheet.Cells["A1:G1"].Merge();
            InitData(worksheet);

            worksheet.Cells["A1"].Value = "Customer Wait Time (in seconds)";
            worksheet.Cells["A1"].Font.ApplyFont(new GrapeCity.Spreadsheet.Font() { Name = "Arial", Size = 17 });
            worksheet.Cells["A1"].VerticalAlignment = VerticalAlignment.Center;

            worksheet.Rows["1"].RowHeight = 30;
            worksheet.Rows["2"].RowHeight = 25;
            worksheet.Rows["4"].RowHeight = 250;
            worksheet.Columns["B:G"].ColumnWidth = 20;

            int branch = 1;
            for (int i = 0; i < 7; i++)
            {
                char column = Convert.ToChar(65 + i);
                worksheet.Cells[$"{column}2"].Value = $"Branch {branch}";
                worksheet.Cells[$"{column}2"].HorizontalAlignment = HorizontalAlignment.Center;
                worksheet.Cells[$"{column}2"].VerticalAlignment = VerticalAlignment.Center;
                worksheet.Cells[$"{column}2"].Font.ApplyFont(new GrapeCity.Spreadsheet.Font() { Name = "Arial", Size = 11, Bold = true });
                sheetView.Cells[$"{column}2"].ForeColor = System.Drawing.Color.White;
                sheetView.Cells[$"{column}2"].BackColor = ColorTranslator.FromHtml("#82bc00");

                if (i < 6)
                {
                    worksheet.Cells[$"{(char)(65 + i + 1)}2"].HorizontalAlignment = HorizontalAlignment.Center;
                    worksheet.Cells[$"{(char)(65 + i + 1)}2"].VerticalAlignment = VerticalAlignment.Center;
                    worksheet.Cells[$"{(char)(65 + i + 1)}2"].Font.ApplyFont(new GrapeCity.Spreadsheet.Font() { Name = "Arial", Size = 11, Bold = true });
                    sheetView.Cells[$"{(char)(65 + i + 1)}2"].ForeColor = System.Drawing.Color.White;
                    sheetView.Cells[$"{(char)(65 + i + 1)}2"].BackColor = ColorTranslator.FromHtml("#82bc00");
                }

                worksheet.Columns[$"{column}"].ColumnWidth = 300;
                worksheet.Cells[$"{column}4"].Formula2 = $"HISTOGRAMSPARKLINE({column}6:{column}50,TRUE,TRUE,10,1,\"#DDDDDD\",\"normal normal 8pt Calibri\", \"#000000\", \"#C0C0C0\")";
                i++;
                branch++;
            }
        }

        private void InitData(IWorksheet sheet)
        {
            for (int row = 6; row <= 50; row++)
            {
                for (int col = 65; col < 72; col++)
                {
                    char columnChar = Convert.ToChar(col);
                    sheet.Cells[$"{columnChar}{row}"].Value = _rand.Next(50, 100);
                    col++;
                }
            }
        }
        #endregion
    }
}


//
//HistogramSparkline.Designer.cs
//



namespace Spread.Sparkline.Features
{
    partial class HistogramSparkline
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(HistogramSparkline));
            this._fpSpread = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, ((object)(resources.GetObject("pnlMain.Controls"))));
            this._fpSpread_Sheet1 = this._fpSpread.GetSheet(0);
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this._fpSpread);
            // 
            // _fpSpread
            // 
            this._fpSpread.Dock = System.Windows.Forms.DockStyle.Fill;
            this._fpSpread.Font = new System.Drawing.Font("Calibri", 11F);
            this._fpSpread.Location = new System.Drawing.Point(0, 0);
            this._fpSpread.Name = "_fpSpread";
            this._fpSpread.Size = new System.Drawing.Size(477, 487);
            this._fpSpread.TabIndex = 0;
            // 
            // HistogramSparkline
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "HistogramSparkline";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread _fpSpread;
        private FarPoint.Win.Spread.SheetView _fpSpread_Sheet1;
    }
}
